package BoostedTest::RDBO::Result;

use strict;

use base qw(BoostedTest::RDBO::DB::Object);

__PACKAGE__->meta->setup(
    table   => 'results',

    columns => [
        id          => { type => 'serial', not_null => 1 },
        testcase_id => { type => 'integer', default => '0', not_null => 1 },
        run_id      => { type => 'integer', default => '0', not_null => 1 },
        result      => { type => 'integer', default => '0' },
        comments    => { type => 'scalar', length => 16777215 },
    ],

    foreign_keys =>
    [
      testcase =>
      {
        class       => 'BoostedTest::RDBO::Testcase',
        key_columns => { testcase_id => 'id' },
      },
      
      run =>
      {
        class       => 'BoostedTest::RDBO::Run',
        key_columns => { run_id => 'id' },
      },
    ],

    primary_key_columns => [ 'id' ],
);

1;

